Tabela LResourceGroup

Definicja tabeli LResourceGroup

Name

LResourceGroup

Code

LResourceGroup

Comment

Tabela definiuje powiazania pomiedzy zasobem a grupa zasobów


Lista kolumn tabeli LResourceGroup

Name

Code

LResourceGroupID

LResourceGroupID

ResourceGroupID

ResourceGroupID

ResourceID

ResourceID

FrequencyID

FrequencyID

ApplicationWayID

ApplicationWayID

SequenceNo

SequenceNo

IsGivenToPatient

IsGivenToPatient

GivenDaysAmount

GivenDaysAmount

OrderLength

OrderLength

UnitsCount

UnitsCount

UnitID

UnitID

Comments

Comments


Kolumna LResourceGroupID tabeli LResourceGroup

Definicja kolumny LResourceGroupID tabeli LResourceGroup

Name

LResourceGroupID

Code

LResourceGroupID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ResourceGroupID tabeli LResourceGroup

Definicja kolumny ResourceGroupID tabeli LResourceGroup

Name

ResourceGroupID

Code

ResourceGroupID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ResourceID tabeli LResourceGroup

Definicja kolumny ResourceID tabeli LResourceGroup

Name

ResourceID

Code

ResourceID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna FrequencyID tabeli LResourceGroup

Definicja kolumny FrequencyID tabeli LResourceGroup

Name

FrequencyID

Code

FrequencyID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ApplicationWayID tabeli LResourceGroup

Definicja kolumny ApplicationWayID tabeli LResourceGroup

Name

ApplicationWayID

Code

ApplicationWayID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna SequenceNo tabeli LResourceGroup

Definicja kolumny SequenceNo tabeli LResourceGroup

Name

SequenceNo

Code

SequenceNo

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna IsGivenToPatient tabeli LResourceGroup

Definicja kolumny IsGivenToPatient tabeli LResourceGroup

Name

IsGivenToPatient

Code

IsGivenToPatient

Data Type

NUMBER(5)

Mandatory

No

Comment

czy lek zostal wydany pacjentowi do domu


Kolumna GivenDaysAmount tabeli LResourceGroup

Definicja kolumny GivenDaysAmount tabeli LResourceGroup

Name

GivenDaysAmount

Code

GivenDaysAmount

Data Type

NUMBER(10)

Mandatory

No

Comment

wydano pacjentowi na n-dni


Kolumna OrderLength tabeli LResourceGroup

Definicja kolumny OrderLength tabeli LResourceGroup

Name

OrderLength

Code

OrderLength

Data Type

NUMBER(10)

Mandatory

No

Comment

dlugosc zlecenia w dniach


Kolumna UnitsCount tabeli LResourceGroup

Definicja kolumny UnitsCount tabeli LResourceGroup

Name

UnitsCount

Code

UnitsCount

Data Type

NUMBER(12,4)

Mandatory

No

Comment

dawka zlecenia leku


Kolumna UnitID tabeli LResourceGroup

Definicja kolumny UnitID tabeli LResourceGroup

Name

UnitID

Code

UnitID

Data Type

NUMBER(10)

Mandatory

No

Comment

jednostka w jakich zlecany jest lek (np. mg)


Kolumna Comments tabeli LResourceGroup

Definicja kolumny Comments tabeli LResourceGroup

Name

Comments

Code

Comments

Data Type

VARCHAR2(255)

Mandatory

No

Comment

komentarz do zlecenia leku


Lista kluczy tabeli LResourceGroup

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli LResourceGroup

Definicja klucza Identifier_1 tabeli LResourceGroup

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment